/*
 Navicat Premium Data Transfer

 Source Server         : my-ELy6s44Jb2PCiNbi
 Source Server Type    : MySQL
 Source Server Version : 80024 (8.0.24)
 Source Host           : 59.110.53.198:3306
 Source Schema         : game_data

 Target Server Type    : MySQL
 Target Server Version : 80024 (8.0.24)
 File Encoding         : 65001

 Date: 22/04/2024 09:35:43
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for group_app
-- ----------------------------
DROP TABLE IF EXISTS `group_app`;
CREATE TABLE `group_app` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `groupId` int NOT NULL DEFAULT '0' COMMENT '应用分组编号(group_manage表主键)',
  `softwareId` int NOT NULL DEFAULT '0' COMMENT '应用编号(software_entity表主键)',
  `showSequence` int NOT NULL DEFAULT '0' COMMENT '应用展示序号',
  `createAccount` int NOT NULL DEFAULT '0' COMMENT '创建人',
  `createTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `editAccount` int NOT NULL DEFAULT '0' COMMENT '修改人',
  `editTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT=' <p>';

-- ----------------------------
-- Records of group_app
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for group_manage
-- ----------------------------
DROP TABLE IF EXISTS `group_manage`;
CREATE TABLE `group_manage` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `groupName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '分组名称',
  `groupImage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '分组图标',
  `groupType` int NOT NULL DEFAULT '0' COMMENT '分组类型：1单列无背景图、2单列有背景图、3双列无背景图',
  `groupModule` int NOT NULL DEFAULT '0' COMMENT '分组模块：1首页、2应用分类页、3排行榜页、4游戏分类页',
  `groupSequence` int NOT NULL DEFAULT '0' COMMENT '分组序号',
  `createAccount` int NOT NULL DEFAULT '0' COMMENT '创建人',
  `createTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `editAccount` int NOT NULL DEFAULT '0' COMMENT '修改人',
  `editTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT=' <p>';

-- ----------------------------
-- Records of group_manage
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for img_entity
-- ----------------------------
DROP TABLE IF EXISTS `img_entity`;
CREATE TABLE `img_entity` (
  `imgId` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `createTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `modifyTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `imgName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '图片名',
  `imgPath` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '图片路径',
  `imgType` int NOT NULL DEFAULT '0' COMMENT '图片类型(1首页轮播图,2EOS专区)',
  `imgBlock` int NOT NULL DEFAULT '0' COMMENT '图片版块',
  `imgForeignKey` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '图片外键id',
  `imgAdderss` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '网址',
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `sort` int DEFAULT NULL,
  PRIMARY KEY (`imgId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT=' <p>';

-- ----------------------------
-- Records of img_entity
-- ----------------------------
BEGIN;
INSERT INTO `img_entity` (`imgId`, `createTime`, `modifyTime`, `imgName`, `imgPath`, `imgType`, `imgBlock`, `imgForeignKey`, `imgAdderss`, `content`, `sort`) VALUES (1, '2024-03-26 00:37:52', '2024-03-26 00:37:52', '测试', 'https://files.gamepro.vip/static/image/20240326/9f9fafa4-533c-4b4d-8ee3-8d22290a1c192972.jpg', 1, 0, '', '', '测试', 0);
INSERT INTO `img_entity` (`imgId`, `createTime`, `modifyTime`, `imgName`, `imgPath`, `imgType`, `imgBlock`, `imgForeignKey`, `imgAdderss`, `content`, `sort`) VALUES (2, '2024-03-26 00:37:52', '2024-03-26 00:37:52', '测试', 'https://files.gamepro.vip/static/image/20240326/9f9fafa4-533c-4b4d-8ee3-8d22290a1c192972.jpg', 1, 0, '', '', '测试', 0);
COMMIT;

-- ----------------------------
-- Table structure for message_entity
-- ----------------------------
DROP TABLE IF EXISTS `message_entity`;
CREATE TABLE `message_entity` (
  `messageId` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `createTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `modifyTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `userId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '留言者id',
  `msgContent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '留言内容',
  `softwareId` int NOT NULL DEFAULT '0' COMMENT '软件id',
  `messageStatus` int NOT NULL DEFAULT '0' COMMENT '评论状态(0未删除,1已删除)',
  `messaeType` int NOT NULL DEFAULT '0' COMMENT '评论审核(1待审核,2已审核,3审核未通过)',
  `score` int NOT NULL DEFAULT '0' COMMENT '评分',
  PRIMARY KEY (`messageId`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT=' <p>';

-- ----------------------------
-- Records of message_entity
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for newsmag_entity
-- ----------------------------
DROP TABLE IF EXISTS `newsmag_entity`;
CREATE TABLE `newsmag_entity` (
  `newsMagId` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `createTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `modifyTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `newsName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '消息名称',
  `newsInfo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '消息展示文字',
  `newsContent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '消息内容',
  `newsType` int NOT NULL DEFAULT '0' COMMENT '消息类型',
  `newsStatus` int NOT NULL DEFAULT '0' COMMENT '消息是否删除(1未删除,2已删除)',
  PRIMARY KEY (`newsMagId`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT=' <p>';

-- ----------------------------
-- Records of newsmag_entity
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for problemfeedback_entity
-- ----------------------------
DROP TABLE IF EXISTS `problemfeedback_entity`;
CREATE TABLE `problemfeedback_entity` (
  `problemFeedbackId` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `createTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `modifyTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `userId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '用户id',
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '反馈内容',
  `problemFeedbackStatus` int NOT NULL DEFAULT '0' COMMENT '反馈是否删除(1.未删除.2已删除)',
  `processingState` int NOT NULL DEFAULT '0' COMMENT '处理状态(1待处理,2已处理,3处理未通过)',
  `appSource` int NOT NULL DEFAULT '0' COMMENT '应用来源：1Bt商店、2Bt头条',
  PRIMARY KEY (`problemFeedbackId`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT=' <p>';

-- ----------------------------
-- Records of problemfeedback_entity
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for software_entity
-- ----------------------------
DROP TABLE IF EXISTS `software_entity`;
CREATE TABLE `software_entity` (
  `softwareId` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `createTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `modifyTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `modifyTime1` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '后台配置的软件修改时间',
  `softwareName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '软件名称',
  `downLoadNum` int NOT NULL DEFAULT '0' COMMENT '下载次数',
  `downLoadNumX` int NOT NULL DEFAULT '0' COMMENT '虚拟下载量',
  `softwareMsg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '软件展示标语',
  `softwarePath` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '软件展示图',
  `softwareForeignKey` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '软件图片外键',
  `softwareIosFilePath` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT 'ios软件文件路径',
  `softwareIosStart` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT 'ios的版本',
  `banner` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `softwareFilePath` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '安卓的软件文件路径',
  `softwareStart` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '安卓的版本',
  `softwareStatus` int NOT NULL DEFAULT '0' COMMENT '软件状态(1未下架,2已下架)',
  `softwareType` int NOT NULL DEFAULT '0' COMMENT '软件类型(1,交易所,2钱包,3行情软件,4工具软件,5新闻资讯,6行业应用,7,区块链游戏,8内容社区)',
  `gameType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '游戏类型(1,策略,2抽卡,3养成,4战斗)',
  `applySize` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '应用大小',
  `applyIntroduce` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '应用介绍',
  `welfareContent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '福利',
  `majorFunction` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主要功能',
  `otherFunction` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '其他功能',
  `candyNum` int NOT NULL DEFAULT '0' COMMENT '糖果数量',
  `hot` int NOT NULL DEFAULT '0' COMMENT '精品游戏(1-8)',
  `accidence` int NOT NULL DEFAULT '0' COMMENT '入门必备(1-8)',
  `priority` int NOT NULL DEFAULT '0' COMMENT '是否推荐(1推荐-2不推荐)',
  `visitNum` int NOT NULL DEFAULT '0' COMMENT '访问量',
  `visitDayNum` int NOT NULL DEFAULT '0' COMMENT '每日访问量',
  `appName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT 'app名称',
  `startTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '初始版本上传时间',
  `infoImg1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '详情图1',
  `infoImg1Long` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `infoImg2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '详情图2',
  `infoImg2Long` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `infoImg3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '详情图3',
  `infoImg3Long` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `infoImg4` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '详情图4',
  `infoImg4Long` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `infoImg5` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '详情图5',
  `infoImg5Long` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `officialWebsiteAddress` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '官网',
  `iosApplySize` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT 'ios包大小',
  `iosUploadAddress` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT 'ISO下载地址',
  `androidUploadAddress` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '安卓下载地址',
  `h5Address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `androidAppSize` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '安卓包大小',
  `smallWeavePriority` int NOT NULL DEFAULT '0' COMMENT '小编推荐(1-8)',
  `prioritySort` int NOT NULL DEFAULT '0' COMMENT '排行榜推荐(1-8)',
  `priority1` int NOT NULL DEFAULT '0' COMMENT '首页热门交易所(1-8)',
  `priorityWallet` int NOT NULL DEFAULT '0' COMMENT '首页主流钱包(1-8)',
  `priority2` int NOT NULL DEFAULT '0' COMMENT '首页行情资讯推荐(1-8)',
  `priority3` int NOT NULL DEFAULT '0' COMMENT '应用工具(1-8)',
  `priority4` int NOT NULL DEFAULT '0' COMMENT '首页出众新锐(1-8)',
  `priority5` int NOT NULL DEFAULT '0' COMMENT '区块链浏览器(1-8)',
  `priority6` int NOT NULL DEFAULT '0' COMMENT '首页区块链游戏(1-8)',
  `priority7` int NOT NULL DEFAULT '0' COMMENT 'EOS专区热门推荐(1-8)',
  `priority8` int NOT NULL DEFAULT '0' COMMENT '游戏分类配置-热门游戏',
  `priority9` int NOT NULL DEFAULT '0' COMMENT '游戏分类配置-最新游戏',
  `priority10` int NOT NULL DEFAULT '0' COMMENT '游戏分类配置-经典回顾',
  `priority11` int NOT NULL DEFAULT '0' COMMENT '游戏分类配置-推荐游戏',
  `hotSearch` int NOT NULL DEFAULT '0' COMMENT '是否热门搜索(1否,2是)',
  `keywords` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '关键字',
  `btVersionStatus` int NOT NULL DEFAULT '0' COMMENT '应用的BT版本标识：1未设置、2Android已设置、3IOS已设置、4都已设置',
  `downloadLimit` int NOT NULL DEFAULT '0' COMMENT '下载量限制',
  `downloadCount` int NOT NULL DEFAULT '0' COMMENT '下载量统计',
  `wordsHeat` int NOT NULL DEFAULT '0' COMMENT '关键词热度',
  `searchHeat` int NOT NULL DEFAULT '0' COMMENT '检索热度',
  `packageName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '应用包名',
  `developerId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '开发者(user_entity)编号',
  `appSign` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '应用签名',
  `appPermission` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '应用权限获取说明',
  `chargeType` int NOT NULL DEFAULT '0' COMMENT '收费类型：1免费、2收费、3部分功能收费、4部分内容收费',
  `adStatus` int NOT NULL DEFAULT '0' COMMENT '广告状态：1无广告、2含广告、3内嵌广告、4通知栏广告',
  `langueType` int NOT NULL DEFAULT '0' COMMENT '支持语言：1简体中文、2繁体中文、3英文、4其它',
  `copyrightAndroid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '电子版权认证证书(安卓)',
  `proveAndroid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '证明材料(安卓)',
  `reportAndroid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '安全评估报告(安卓)',
  `urlschemaIphone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT 'URL schema(iphone)',
  `appstoreidIphone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT 'AppStoreId(iphone)',
  `bundleidIphone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT 'bundle id(iphone)',
  `urlschemaIpad` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT 'URL schema(ipad)',
  `appstoreidIpad` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT 'AppStoreId(ipad)',
  `bundleidIpad` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT 'bundle id(ipad)',
  `checkTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '应用审核时间',
  `checkMessage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '应用审核描述',
  `commentScore` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '应用的用户评分',
  `versionNo` int NOT NULL DEFAULT '0' COMMENT 'Android版本号',
  `videoUrl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '应用的短视频介绍',
  `pageinfoUrl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '应用的PC端详情页链接地址',
  `pageinfoStatus` int NOT NULL DEFAULT '0' COMMENT '应用的PC端详情页状态：1未生成、2已生成',
  `pageinfoTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '应用的PC端详情页生成时间',
  `score` int NOT NULL DEFAULT '0' COMMENT '评分',
  `scoreX` int NOT NULL DEFAULT '0' COMMENT '虚拟评分',
  `targertType` int NOT NULL DEFAULT '0',
  `versionName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `versionCode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `appSize` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `bannervideo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `html` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `developersname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  PRIMARY KEY (`softwareId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT=' <p>';

-- ----------------------------
-- Records of software_entity
-- ----------------------------
BEGIN;
INSERT INTO `software_entity` (`softwareId`, `createTime`, `modifyTime`, `modifyTime1`, `softwareName`, `downLoadNum`, `downLoadNumX`, `softwareMsg`, `softwarePath`, `softwareForeignKey`, `softwareIosFilePath`, `softwareIosStart`, `banner`, `softwareFilePath`, `softwareStart`, `softwareStatus`, `softwareType`, `gameType`, `applySize`, `applyIntroduce`, `welfareContent`, `majorFunction`, `otherFunction`, `candyNum`, `hot`, `accidence`, `priority`, `visitNum`, `visitDayNum`, `appName`, `startTime`, `infoImg1`, `infoImg1Long`, `infoImg2`, `infoImg2Long`, `infoImg3`, `infoImg3Long`, `infoImg4`, `infoImg4Long`, `infoImg5`, `infoImg5Long`, `officialWebsiteAddress`, `iosApplySize`, `iosUploadAddress`, `androidUploadAddress`, `h5Address`, `androidAppSize`, `smallWeavePriority`, `prioritySort`, `priority1`, `priorityWallet`, `priority2`, `priority3`, `priority4`, `priority5`, `priority6`, `priority7`, `priority8`, `priority9`, `priority10`, `priority11`, `hotSearch`, `keywords`, `btVersionStatus`, `downloadLimit`, `downloadCount`, `wordsHeat`, `searchHeat`, `packageName`, `developerId`, `appSign`, `appPermission`, `chargeType`, `adStatus`, `langueType`, `copyrightAndroid`, `proveAndroid`, `reportAndroid`, `urlschemaIphone`, `appstoreidIphone`, `bundleidIphone`, `urlschemaIpad`, `appstoreidIpad`, `bundleidIpad`, `checkTime`, `checkMessage`, `commentScore`, `versionNo`, `videoUrl`, `pageinfoUrl`, `pageinfoStatus`, `pageinfoTime`, `score`, `scoreX`, `targertType`, `versionName`, `versionCode`, `appSize`, `bannervideo`, `source`, `html`, `developersname`) VALUES (1, '2024-03-26 00:45:33', '2024-03-26 00:45:33', '2024-03-26 00:45:33', '1', 0, 0, '', '', '', '', '', '', '', '', 0, 1, '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, '', '2024-03-26 00:45:33', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, '', '', '', '', 0, 0, 0, '', '', '', '', '', '', '', '', '', '2024-03-26 00:45:33', '', '', 0, '', '', 0, '2024-03-26 00:45:33', 0, 0, 0, '', '', '', '', NULL, NULL, NULL);
INSERT INTO `software_entity` (`softwareId`, `createTime`, `modifyTime`, `modifyTime1`, `softwareName`, `downLoadNum`, `downLoadNumX`, `softwareMsg`, `softwarePath`, `softwareForeignKey`, `softwareIosFilePath`, `softwareIosStart`, `banner`, `softwareFilePath`, `softwareStart`, `softwareStatus`, `softwareType`, `gameType`, `applySize`, `applyIntroduce`, `welfareContent`, `majorFunction`, `otherFunction`, `candyNum`, `hot`, `accidence`, `priority`, `visitNum`, `visitDayNum`, `appName`, `startTime`, `infoImg1`, `infoImg1Long`, `infoImg2`, `infoImg2Long`, `infoImg3`, `infoImg3Long`, `infoImg4`, `infoImg4Long`, `infoImg5`, `infoImg5Long`, `officialWebsiteAddress`, `iosApplySize`, `iosUploadAddress`, `androidUploadAddress`, `h5Address`, `androidAppSize`, `smallWeavePriority`, `prioritySort`, `priority1`, `priorityWallet`, `priority2`, `priority3`, `priority4`, `priority5`, `priority6`, `priority7`, `priority8`, `priority9`, `priority10`, `priority11`, `hotSearch`, `keywords`, `btVersionStatus`, `downloadLimit`, `downloadCount`, `wordsHeat`, `searchHeat`, `packageName`, `developerId`, `appSign`, `appPermission`, `chargeType`, `adStatus`, `langueType`, `copyrightAndroid`, `proveAndroid`, `reportAndroid`, `urlschemaIphone`, `appstoreidIphone`, `bundleidIphone`, `urlschemaIpad`, `appstoreidIpad`, `bundleidIpad`, `checkTime`, `checkMessage`, `commentScore`, `versionNo`, `videoUrl`, `pageinfoUrl`, `pageinfoStatus`, `pageinfoTime`, `score`, `scoreX`, `targertType`, `versionName`, `versionCode`, `appSize`, `bannervideo`, `source`, `html`, `developersname`) VALUES (2, '2024-03-26 00:46:26', '2024-03-26 00:46:26', '2024-03-26 00:46:26', '1', 0, 0, '', '', '', '', '', '', '', '', 0, 1, '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, '', '2024-03-26 00:46:26', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, '', '', '', '', 0, 0, 0, '', '', '', '', '', '', '', '', '', '2024-03-26 00:46:26', '', '', 0, '', '', 0, '2024-03-26 00:46:26', 0, 0, 0, '', '', '', '', NULL, NULL, NULL);
INSERT INTO `software_entity` (`softwareId`, `createTime`, `modifyTime`, `modifyTime1`, `softwareName`, `downLoadNum`, `downLoadNumX`, `softwareMsg`, `softwarePath`, `softwareForeignKey`, `softwareIosFilePath`, `softwareIosStart`, `banner`, `softwareFilePath`, `softwareStart`, `softwareStatus`, `softwareType`, `gameType`, `applySize`, `applyIntroduce`, `welfareContent`, `majorFunction`, `otherFunction`, `candyNum`, `hot`, `accidence`, `priority`, `visitNum`, `visitDayNum`, `appName`, `startTime`, `infoImg1`, `infoImg1Long`, `infoImg2`, `infoImg2Long`, `infoImg3`, `infoImg3Long`, `infoImg4`, `infoImg4Long`, `infoImg5`, `infoImg5Long`, `officialWebsiteAddress`, `iosApplySize`, `iosUploadAddress`, `androidUploadAddress`, `h5Address`, `androidAppSize`, `smallWeavePriority`, `prioritySort`, `priority1`, `priorityWallet`, `priority2`, `priority3`, `priority4`, `priority5`, `priority6`, `priority7`, `priority8`, `priority9`, `priority10`, `priority11`, `hotSearch`, `keywords`, `btVersionStatus`, `downloadLimit`, `downloadCount`, `wordsHeat`, `searchHeat`, `packageName`, `developerId`, `appSign`, `appPermission`, `chargeType`, `adStatus`, `langueType`, `copyrightAndroid`, `proveAndroid`, `reportAndroid`, `urlschemaIphone`, `appstoreidIphone`, `bundleidIphone`, `urlschemaIpad`, `appstoreidIpad`, `bundleidIpad`, `checkTime`, `checkMessage`, `commentScore`, `versionNo`, `videoUrl`, `pageinfoUrl`, `pageinfoStatus`, `pageinfoTime`, `score`, `scoreX`, `targertType`, `versionName`, `versionCode`, `appSize`, `bannervideo`, `source`, `html`, `developersname`) VALUES (3, '2024-03-26 08:31:17', '2024-03-26 08:31:17', '2024-03-26 08:31:17', '123', 0, 0, '', 'https://loansmanage.oss-cn-beijing.aliyuncs.com/static/image/20240326/6e40e5a0-9807-4789-85b3-0cab04e6e6240951.jpg', '', '', '', '', '', '', 0, 1, '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, '', '2024-03-26 08:31:17', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, '', '', '', '', 0, 0, 0, '', '', '', '', '', '', '', '', '', '2024-03-26 08:31:17', '', '', 0, '', '', 0, '2024-03-26 08:31:17', 0, 0, 0, '', '', '', '', NULL, NULL, NULL);
INSERT INTO `software_entity` (`softwareId`, `createTime`, `modifyTime`, `modifyTime1`, `softwareName`, `downLoadNum`, `downLoadNumX`, `softwareMsg`, `softwarePath`, `softwareForeignKey`, `softwareIosFilePath`, `softwareIosStart`, `banner`, `softwareFilePath`, `softwareStart`, `softwareStatus`, `softwareType`, `gameType`, `applySize`, `applyIntroduce`, `welfareContent`, `majorFunction`, `otherFunction`, `candyNum`, `hot`, `accidence`, `priority`, `visitNum`, `visitDayNum`, `appName`, `startTime`, `infoImg1`, `infoImg1Long`, `infoImg2`, `infoImg2Long`, `infoImg3`, `infoImg3Long`, `infoImg4`, `infoImg4Long`, `infoImg5`, `infoImg5Long`, `officialWebsiteAddress`, `iosApplySize`, `iosUploadAddress`, `androidUploadAddress`, `h5Address`, `androidAppSize`, `smallWeavePriority`, `prioritySort`, `priority1`, `priorityWallet`, `priority2`, `priority3`, `priority4`, `priority5`, `priority6`, `priority7`, `priority8`, `priority9`, `priority10`, `priority11`, `hotSearch`, `keywords`, `btVersionStatus`, `downloadLimit`, `downloadCount`, `wordsHeat`, `searchHeat`, `packageName`, `developerId`, `appSign`, `appPermission`, `chargeType`, `adStatus`, `langueType`, `copyrightAndroid`, `proveAndroid`, `reportAndroid`, `urlschemaIphone`, `appstoreidIphone`, `bundleidIphone`, `urlschemaIpad`, `appstoreidIpad`, `bundleidIpad`, `checkTime`, `checkMessage`, `commentScore`, `versionNo`, `videoUrl`, `pageinfoUrl`, `pageinfoStatus`, `pageinfoTime`, `score`, `scoreX`, `targertType`, `versionName`, `versionCode`, `appSize`, `bannervideo`, `source`, `html`, `developersname`) VALUES (4, '2024-03-26 11:37:22', '2024-03-26 11:37:22', '2024-03-26 11:37:22', 'hahh', 0, 0, '', '', '', '', '', '', '', '', 0, 1, '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, '', '2024-03-26 11:37:22', '', '', '', '', '', '', '', '', '', '', '', '', '', 'https://vschool.oss-cn-beijing.aliyuncs.com/upload/正式服.apk', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 'com.mir3.test.gamepro', '', '', '', 0, 0, 0, '', '', '', '', '', '', '', '', '', '2024-03-26 11:37:22', '', '', 0, '', '', 0, '2024-03-26 11:37:22', 0, 0, 0, '1.0.0', '45', '178.20MB', '', NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for softwaretype_entity
-- ----------------------------
DROP TABLE IF EXISTS `softwaretype_entity`;
CREATE TABLE `softwaretype_entity` (
  `softwareTypeId` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `createTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `modifyTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `imgPath` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '图片（尺寸说明）',
  `typeName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '分类名称',
  `typeEngName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '英文名称',
  `softwareTypeStatus` int NOT NULL DEFAULT '0' COMMENT '分类是否删除(1,未删除,2已删除)',
  `hotType` int NOT NULL DEFAULT '0' COMMENT '是否是热门分类(1否,2是)',
  `hotTypeImgPath` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '热门软件展示图',
  `hotSearch` int NOT NULL DEFAULT '0' COMMENT '是否热门搜索(1不是,2是)',
  `orderSequence` int NOT NULL DEFAULT '0' COMMENT '排序字段',
  `gameTypeNum` int NOT NULL DEFAULT '0' COMMENT '标识字段：不再使用ID',
  PRIMARY KEY (`softwareTypeId`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT=' <p>';

-- ----------------------------
-- Records of softwaretype_entity
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for t_friends_circle
-- ----------------------------
DROP TABLE IF EXISTS `t_friends_circle`;
CREATE TABLE `t_friends_circle` (
  `cid` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `cuuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '生成的随机id',
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '内容',
  `pictureaddr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '图片路径',
  `creationtime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '发布时间',
  `creationaddr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '动态发布位置',
  `longitude` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '发布经度',
  `latitude` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '发布纬度',
  `cphone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '号码绑定是谁发的动态',
  `userImg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '用户头像',
  `userNIName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '用户名',
  `gender` int NOT NULL DEFAULT '0' COMMENT '1男、2女',
  `age` int NOT NULL DEFAULT '0' COMMENT '年龄',
  `audit` int NOT NULL DEFAULT '0' COMMENT '审核-- 0:通过  1:不通过 3:被举报',
  `viewStatus` int NOT NULL DEFAULT '0',
  `replyStatus` int NOT NULL DEFAULT '0',
  `topSort` int NOT NULL DEFAULT '0',
  `uid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '打招呼使用',
  `userId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '用户ID',
  `reportdynamicdetails` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '举报动态理由',
  `sid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `tag` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `type` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`cid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT=' <p>';

-- ----------------------------
-- Records of t_friends_circle
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for t_friends_circle_reply
-- ----------------------------
DROP TABLE IF EXISTS `t_friends_circle_reply`;
CREATE TABLE `t_friends_circle_reply` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `fid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '朋友圈ID',
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '内容',
  `owenerId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '拥有者ID',
  `followUpUserId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '评论人ID',
  `pid` bigint NOT NULL DEFAULT '0' COMMENT '评论人ID2',
  `rid` bigint NOT NULL DEFAULT '0',
  `followUpUserName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '评论人名称',
  `followUpUserImg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '评论人头像',
  `level` int NOT NULL DEFAULT '0' COMMENT '评论级别',
  `status` int NOT NULL DEFAULT '0' COMMENT '状态',
  `createTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT=' <p>';

-- ----------------------------
-- Records of t_friends_circle_reply
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for t_friends_click
-- ----------------------------
DROP TABLE IF EXISTS `t_friends_click`;
CREATE TABLE `t_friends_click` (
  `cid` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `circle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '瞬间标识',
  `clicktime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '点赞时间',
  `clickuserId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '点赞人标识',
  `type` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`cid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT=' <p>';

-- ----------------------------
-- Records of t_friends_click
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for tbappcorrelation
-- ----------------------------
DROP TABLE IF EXISTS `tbappcorrelation`;
CREATE TABLE `tbappcorrelation` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `oid` bigint NOT NULL DEFAULT '0' COMMENT 'oid',
  `sid` bigint NOT NULL DEFAULT '0' COMMENT 'sid',
  `adminid` bigint NOT NULL DEFAULT '0' COMMENT 'adminid',
  `type` int NOT NULL DEFAULT '0' COMMENT '类型：0，排行榜关联',
  `status` int NOT NULL DEFAULT '0' COMMENT '状态：0:未启用，1:启用，2、下架',
  `sortNum` int NOT NULL DEFAULT '0' COMMENT '排序',
  `extra` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '扩展',
  `createTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建日期',
  `updateTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新日期',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT=' <p>';

-- ----------------------------
-- Records of tbappcorrelation
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for tbattention
-- ----------------------------
DROP TABLE IF EXISTS `tbattention`;
CREATE TABLE `tbattention` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `userid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '用户id',
  `attentionuserid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '关注人id',
  `createTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '关注时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT=' <p>';

-- ----------------------------
-- Records of tbattention
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for tbconfig
-- ----------------------------
DROP TABLE IF EXISTS `tbconfig`;
CREATE TABLE `tbconfig` (
  `id` bigint NOT NULL DEFAULT '0' COMMENT 'ID',
  `memo` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '内容',
  `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
  `updateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='配置信息表';

-- ----------------------------
-- Records of tbconfig
-- ----------------------------
BEGIN;
INSERT INTO `tbconfig` (`id`, `memo`, `content`, `createTime`, `updateTime`) VALUES (0, '版本信息配置', '{\n    \"APPID\":\"wxaf33af947694e94b\",\n		\"SECRET\":\"05022d6ce328e351ea5caf95a34b4158\"\n}', '2023-01-19 18:35:51', '2023-11-15 22:01:58');
INSERT INTO `tbconfig` (`id`, `memo`, `content`, `createTime`, `updateTime`) VALUES (1, '分享信息配置', '{\n    \"icon\":\"https://files.gamepro.vip/system/icon2.png\",\n    \"shareApp\":{\n        \"url\":\"https://m.gamepro.vip\",\n        \"title\":\"游戏玩家APP-游戏社交圈\",\n				\"content\":\"获取精品游戏资讯，领取高价值游戏福利，探索更有趣的游戏世界,尽在游戏玩家，赶快来下载吧\"\n    },\n    \"shareGame\":{\n        \"url\":\"https://m.gamepro.vip/detail.html\",\n        \"title\":\"\",\n				\"content\":\"\"\n    }\n}', '2023-06-08 15:07:16', '2023-07-24 13:13:26');
INSERT INTO `tbconfig` (`id`, `memo`, `content`, `createTime`, `updateTime`) VALUES (2, '排行信息配置', '[\n    {\n        \"id\":1,\n        \"name\":\"排行榜模块\"\n    },{\n        \"id\":2,\n        \"name\":\"测试模块\"\n    }\n]', '2023-06-21 12:14:06', '2023-06-21 18:15:09');
INSERT INTO `tbconfig` (`id`, `memo`, `content`, `createTime`, `updateTime`) VALUES (3, '分组信息配置', '{\n    \"module\":[\n        {\n            \"id\":1,\n            \"name\":\"首页\"\n        },\n        {\n            \"id\":2,\n            \"name\":\"云玩\"\n        }\n    ],\n    \"type\":[\n        {\n            \"id\":1,\n            \"name\":\"单列无背景图\"\n        },\n        {\n            \"id\":2,\n            \"name\":\"单列有背景图\"\n        },\n				{\n            \"id\":3,\n            \"name\":\"双列无背景图\"\n        },\n        {\n            \"id\":4,\n            \"name\":\"双列有背景图\"\n        }\n    ]\n}', '2023-06-21 18:08:14', '2023-06-21 19:02:17');
INSERT INTO `tbconfig` (`id`, `memo`, `content`, `createTime`, `updateTime`) VALUES (4, '短信配置', '{\n		\"type\":1,\n		\"hx\":2,\n		\"ali\":8\n}', '2023-06-30 19:57:16', '2023-06-30 20:14:17');
INSERT INTO `tbconfig` (`id`, `memo`, `content`, `createTime`, `updateTime`) VALUES (5, '软件来源', '[\n    {\n        \"type\":\"aiQi\",\n        \"name\":\"艾七\"\n    },{\n        \"type\":\"fengKuangTiYu\",\n        \"name\":\"疯狂体育\"\n    },{\n        \"type\":\"jiuYou\",\n        \"name\":\"九游\"\n    },{\n        \"type\":\"miduomi\",\n        \"name\":\"咪多咪\"\n    },{\n        \"type\":\"jiuYou\",\n        \"name\":\"九游\"\n    }\n]', '2023-07-04 17:16:11', '2023-07-04 17:20:33');
COMMIT;

-- ----------------------------
-- Table structure for tbimpush
-- ----------------------------
DROP TABLE IF EXISTS `tbimpush`;
CREATE TABLE `tbimpush` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '标题',
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '内容',
  `system` int NOT NULL DEFAULT '0' COMMENT '系统',
  `img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '图片',
  `appid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT 'appid',
  `sid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `robotId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `pushCount` int NOT NULL DEFAULT '0' COMMENT '图片',
  `handleCount` int NOT NULL DEFAULT '0',
  `extra` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `status` int NOT NULL DEFAULT '0',
  `createTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '关注时间',
  `finishTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '关注时间',
  `userId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT=' <p>';

-- ----------------------------
-- Records of tbimpush
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for tbsoftwarecategory
-- ----------------------------
DROP TABLE IF EXISTS `tbsoftwarecategory`;
CREATE TABLE `tbsoftwarecategory` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `pid` bigint NOT NULL DEFAULT '0' COMMENT 'pid',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '名称',
  `nameEng` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '英文名称',
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '图标',
  `img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '展示图',
  `type` int NOT NULL DEFAULT '0' COMMENT '类型：0，软件类型 1、 游戏1级 2、游戏2级',
  `hotTypeStatus` int NOT NULL DEFAULT '0' COMMENT '热门分类状态：0否,1是',
  `hotSearchStatus` int NOT NULL DEFAULT '0' COMMENT '热门搜索状态：0否,1是',
  `status` int NOT NULL DEFAULT '0' COMMENT '状态：0:未启用，1:启用，2、下架',
  `sortNum` int NOT NULL DEFAULT '0' COMMENT '排序',
  `extra` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '扩展',
  `createTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建日期',
  `updateTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建日期',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT=' <p>';

-- ----------------------------
-- Records of tbsoftwarecategory
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for tbsoftwaregroup
-- ----------------------------
DROP TABLE IF EXISTS `tbsoftwaregroup`;
CREATE TABLE `tbsoftwaregroup` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `groupName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '名称',
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '图标',
  `groupImg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '展示图',
  `groupVideo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '视频',
  `groupType` int NOT NULL DEFAULT '0' COMMENT '类型：1单列无背景图、2单列有背景图、3双列无背景图',
  `groupModule` int NOT NULL DEFAULT '0' COMMENT '模块：1首页，2云玩',
  `status` int NOT NULL DEFAULT '0' COMMENT '状态：0:未启用，1:启用，2、下架',
  `sortNum` int NOT NULL DEFAULT '0' COMMENT '排序',
  `extra` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '扩展',
  `createTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建日期',
  `updateTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新日期',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT=' <p>';

-- ----------------------------
-- Records of tbsoftwaregroup
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for tbsoftwarerankings
-- ----------------------------
DROP TABLE IF EXISTS `tbsoftwarerankings`;
CREATE TABLE `tbsoftwarerankings` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `pid` bigint NOT NULL DEFAULT '0' COMMENT 'pid',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '名称',
  `nameEng` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '英文名称',
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '图标',
  `img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '展示图',
  `type` int NOT NULL DEFAULT '0' COMMENT '类型：0，软件类型 1、 游戏1级 2、游戏2级',
  `hotTypeStatus` int NOT NULL DEFAULT '0' COMMENT '热门分类状态：0否,1是',
  `hotSearchStatus` int NOT NULL DEFAULT '0' COMMENT '热门搜索状态：0否,1是',
  `status` int NOT NULL DEFAULT '0' COMMENT '状态：0:未启用，1:启用，2、下架',
  `sortNum` int NOT NULL DEFAULT '0' COMMENT '排序',
  `extra` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '扩展',
  `createTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建日期',
  `updateTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新日期',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT=' <p>';

-- ----------------------------
-- Records of tbsoftwarerankings
-- ----------------------------
BEGIN;
INSERT INTO `tbsoftwarerankings` (`id`, `pid`, `name`, `nameEng`, `icon`, `img`, `type`, `hotTypeStatus`, `hotSearchStatus`, `status`, `sortNum`, `extra`, `createTime`, `updateTime`) VALUES (1, 0, '热门游戏', '', '', '', 1, 0, 0, 1, 1, '', '2024-03-26 00:52:39', '2024-03-26 00:52:39');
INSERT INTO `tbsoftwarerankings` (`id`, `pid`, `name`, `nameEng`, `icon`, `img`, `type`, `hotTypeStatus`, `hotSearchStatus`, `status`, `sortNum`, `extra`, `createTime`, `updateTime`) VALUES (2, 0, '休闲游戏', '', '', '', 1, 0, 0, 1, 2, '', '2024-03-26 00:52:37', '2024-03-26 00:52:37');
COMMIT;

-- ----------------------------
-- Table structure for tbtipoff
-- ----------------------------
DROP TABLE IF EXISTS `tbtipoff`;
CREATE TABLE `tbtipoff` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `userid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '用户id',
  `adminId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `oid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `reply` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `type` int NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '0',
  `createTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '时间',
  `updateTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT=' <p>';

-- ----------------------------
-- Records of tbtipoff
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for tbtopic
-- ----------------------------
DROP TABLE IF EXISTS `tbtopic`;
CREATE TABLE `tbtopic` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `topic` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `sid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `sortNum` int NOT NULL DEFAULT '0',
  `viewCount` int NOT NULL DEFAULT '0',
  `type` int NOT NULL DEFAULT '0',
  `createTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT=' <p>';

-- ----------------------------
-- Records of tbtopic
-- ----------------------------
BEGIN;
INSERT INTO `tbtopic` (`id`, `icon`, `topic`, `sid`, `sortNum`, `viewCount`, `type`, `createTime`) VALUES (1, '', '1', '1', 0, 0, 0, '2024-03-26 00:45:33');
INSERT INTO `tbtopic` (`id`, `icon`, `topic`, `sid`, `sortNum`, `viewCount`, `type`, `createTime`) VALUES (2, '', '1', '2', 0, 0, 0, '2024-03-26 00:46:26');
INSERT INTO `tbtopic` (`id`, `icon`, `topic`, `sid`, `sortNum`, `viewCount`, `type`, `createTime`) VALUES (3, 'https://loansmanage.oss-cn-beijing.aliyuncs.com/static/image/20240326/6e40e5a0-9807-4789-85b3-0cab04e6e6240951.jpg', '123', '3', 0, 0, 0, '2024-03-26 08:31:17');
INSERT INTO `tbtopic` (`id`, `icon`, `topic`, `sid`, `sortNum`, `viewCount`, `type`, `createTime`) VALUES (4, '', 'hahh', '4', 0, 0, 0, '2024-03-26 11:37:22');
COMMIT;

-- ----------------------------
-- Table structure for tbuserreport
-- ----------------------------
DROP TABLE IF EXISTS `tbuserreport`;
CREATE TABLE `tbuserreport` (
  `id` int DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `registcount` bigint DEFAULT NULL,
  `activecount` bigint DEFAULT NULL,
  `createtime` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of tbuserreport
-- ----------------------------
BEGIN;
INSERT INTO `tbuserreport` (`id`, `date`, `source`, `registcount`, `activecount`, `createtime`) VALUES (NULL, '2024-03-26 00:00:00', '_360', 1, 0, NULL);
INSERT INTO `tbuserreport` (`id`, `date`, `source`, `registcount`, `activecount`, `createtime`) VALUES (NULL, '2024-03-26 00:00:00', '', 10, 0, NULL);
INSERT INTO `tbuserreport` (`id`, `date`, `source`, `registcount`, `activecount`, `createtime`) VALUES (NULL, '2024-03-26 00:00:00', 'official', 1, 0, NULL);
INSERT INTO `tbuserreport` (`id`, `date`, `source`, `registcount`, `activecount`, `createtime`) VALUES (NULL, '2024-03-27 00:00:00', 'official', 1, 0, NULL);
INSERT INTO `tbuserreport` (`id`, `date`, `source`, `registcount`, `activecount`, `createtime`) VALUES (NULL, '2024-03-28 00:00:00', 'official', 1, 0, NULL);
COMMIT;

-- ----------------------------
-- Table structure for tbvisitlog
-- ----------------------------
DROP TABLE IF EXISTS `tbvisitlog`;
CREATE TABLE `tbvisitlog` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `userid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户id',
  `oid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '其他id',
  `type` int NOT NULL DEFAULT '0',
  `createTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '关注时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COMMENT=' <p>';

-- ----------------------------
-- Records of tbvisitlog
-- ----------------------------
BEGIN;
INSERT INTO `tbvisitlog` (`id`, `userid`, `oid`, `type`, `createTime`) VALUES (1, '', '', 0, '2024-03-25 22:22:44');
COMMIT;

-- ----------------------------
-- Table structure for user_entity
-- ----------------------------
DROP TABLE IF EXISTS `user_entity`;
CREATE TABLE `user_entity` (
  `userId` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `createTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `modifyTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `userWxLoginKey` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '第三方微信唯一标识符',
  `userQqKey` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '第三方qq唯一标识符',
  `userPhone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '用户手机号',
  `phoneDeviceId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '手机设备Id',
  `userPwd` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '用户密码',
  `userNIName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '用户名',
  `openId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '用户唯一标识符',
  `accessToken` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '调用接口需要用到的token',
  `expiredTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '授权过期时间',
  `userImg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '用户头像',
  `bgImg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `userWxLogin` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '用户微信',
  `userQqLogin` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '用户QQ号',
  `userNum` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '用户账号',
  `propelling` int NOT NULL DEFAULT '0' COMMENT '是否推送(1不推送,2推送)',
  `candyNum` int NOT NULL DEFAULT '0' COMMENT '糖果数量',
  `versionInfoId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '版本更新主键',
  `deleteUser` int NOT NULL DEFAULT '0' COMMENT '启用-禁用(1-启用,2-禁用)',
  `identityId` int NOT NULL DEFAULT '0' COMMENT '身份证表主键',
  `invitationCode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '邀请码',
  `firstLogin` int NOT NULL DEFAULT '0' COMMENT '是否初次登录(1初次登录,2非初次登录)',
  `firstUpdateName` int NOT NULL DEFAULT '0' COMMENT '是否修改过用户名(1否,2是)',
  `dayCandyNum` int NOT NULL DEFAULT '0' COMMENT '每天的分享糖果数量',
  `downLoadNumy` int NOT NULL DEFAULT '0' COMMENT '每日下载APP糖果数量',
  `registerSource` int NOT NULL DEFAULT '0' COMMENT '注册来源：1Bt商店、2Bt头条',
  `registerSystem` int NOT NULL DEFAULT '0' COMMENT '注册系统标识：1Android、2IOS',
  `loginSystem` int NOT NULL DEFAULT '0' COMMENT '登录系统标识：1Android、2IOS',
  `loginTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '登录时间',
  `updateVersion` int NOT NULL DEFAULT '0' COMMENT '账户更新版本号，更新即自增1',
  `candyFreeze` int NOT NULL DEFAULT '0' COMMENT '金币冻结账户',
  `toutiaoCandyDay` int NOT NULL DEFAULT '0' COMMENT '头条每日得金币累计数量',
  `userType` int NOT NULL DEFAULT '0' COMMENT '身份类型：1普通用户、2企业开发者、3个人开发者',
  `developerStatus` int NOT NULL DEFAULT '0' COMMENT '开发者认证状态：1未认证、已认证',
  `userIp` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '用户手机IP地址',
  `phoneMac` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '手机mac地址',
  `phoneBrand` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '手机品牌',
  `phoneModel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '手机型号',
  `phoneLevel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '手机系统版本代号(如20)',
  `registerChannel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '注册渠道来源',
  `btchatStatus` int NOT NULL DEFAULT '0' COMMENT '1chat用户',
  `loginAddress` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '登录位置',
  `longitude` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '登录经度',
  `latitude` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '登录纬度',
  `gender` int NOT NULL DEFAULT '0' COMMENT '1男、2女',
  `birthday` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '生日',
  `age` int NOT NULL DEFAULT '0' COMMENT '年龄',
  `occupation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '职业',
  `signature` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '个性签名',
  `chatNo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '大学生号(对应IM服务t_user表_name)',
  `xingzuo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '星座',
  `detailsaddr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `ifvip` int NOT NULL DEFAULT '0' COMMENT '800:不是vip，866:月vip，886:季vip，888:年vip，666内部使用',
  `startvip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '会员开始时间',
  `endvip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT 'vip到期时间',
  `nearbycount` int NOT NULL DEFAULT '0' COMMENT '附近的人查看次数限制',
  `greetuser` int NOT NULL DEFAULT '0' COMMENT '打招呼次数限制',
  `secret` int NOT NULL DEFAULT '0' COMMENT '私聊次数统计',
  `mark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '注册渠道',
  `userexist` int NOT NULL DEFAULT '0' COMMENT '是否是真实用户0：真实用户，1：虚拟用户',
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `adminid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  PRIMARY KEY (`userId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=349627612580020225 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT=' <p>';

-- ----------------------------
-- Records of user_entity
-- ----------------------------
BEGIN;
INSERT INTO `user_entity` (`userId`, `createTime`, `modifyTime`, `userWxLoginKey`, `userQqKey`, `userPhone`, `phoneDeviceId`, `userPwd`, `userNIName`, `openId`, `accessToken`, `expiredTime`, `userImg`, `bgImg`, `userWxLogin`, `userQqLogin`, `userNum`, `propelling`, `candyNum`, `versionInfoId`, `deleteUser`, `identityId`, `invitationCode`, `firstLogin`, `firstUpdateName`, `dayCandyNum`, `downLoadNumy`, `registerSource`, `registerSystem`, `loginSystem`, `loginTime`, `updateVersion`, `candyFreeze`, `toutiaoCandyDay`, `userType`, `developerStatus`, `userIp`, `phoneMac`, `phoneBrand`, `phoneModel`, `phoneLevel`, `registerChannel`, `btchatStatus`, `loginAddress`, `longitude`, `latitude`, `gender`, `birthday`, `age`, `occupation`, `signature`, `chatNo`, `xingzuo`, `detailsaddr`, `ifvip`, `startvip`, `endvip`, `nearbycount`, `greetuser`, `secret`, `mark`, `userexist`, `city`, `adminid`) VALUES (349217295106572288, '2024-03-26 11:18:39', '2024-03-26 11:18:39', '', '', '18310257003', '', '', '侯坎', '', '', '2024-03-26 11:18:39', 'https://files.gamepro.vip/system/headpic/Square/23.png', 'https://files.gamepro.vip/system/bg_1.jpg', '', '', '', 0, 0, '', 0, 0, '', 0, 0, 0, 0, 0, 1, 1, '2024-03-26 11:18:39', 0, 0, 0, 0, 0, '', '', '', '', '', '', 0, '', 0.00, 0.00, 1, '', 0, '', '', '', '', '', 0, '', '', 0, 0, 0, '_360', 0, '', NULL);
INSERT INTO `user_entity` (`userId`, `createTime`, `modifyTime`, `userWxLoginKey`, `userQqKey`, `userPhone`, `phoneDeviceId`, `userPwd`, `userNIName`, `openId`, `accessToken`, `expiredTime`, `userImg`, `bgImg`, `userWxLogin`, `userQqLogin`, `userNum`, `propelling`, `candyNum`, `versionInfoId`, `deleteUser`, `identityId`, `invitationCode`, `firstLogin`, `firstUpdateName`, `dayCandyNum`, `downLoadNumy`, `registerSource`, `registerSystem`, `loginSystem`, `loginTime`, `updateVersion`, `candyFreeze`, `toutiaoCandyDay`, `userType`, `developerStatus`, `userIp`, `phoneMac`, `phoneBrand`, `phoneModel`, `phoneLevel`, `registerChannel`, `btchatStatus`, `loginAddress`, `longitude`, `latitude`, `gender`, `birthday`, `age`, `occupation`, `signature`, `chatNo`, `xingzuo`, `detailsaddr`, `ifvip`, `startvip`, `endvip`, `nearbycount`, `greetuser`, `secret`, `mark`, `userexist`, `city`, `adminid`) VALUES (349231814788775936, '2024-03-26 12:16:19', '2024-03-26 12:16:19', '', '', '88800001', '', '', '陈铃', '', '', '2024-03-26 12:16:19', 'http://files.gamepro.vip/system/headpic/Square/32.png', 'http://files.gamepro.vip/system/bg_1.jpg', '', '', '', 0, 0, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, '2024-03-26 12:16:19', 0, 0, 0, 0, 0, '', '', '', '', '', '', 0, '', 0.00, 0.00, 1, '', 0, '', '', '', '', '', 0, '', '', 0, 0, 0, '', 1, '郑州', NULL);
INSERT INTO `user_entity` (`userId`, `createTime`, `modifyTime`, `userWxLoginKey`, `userQqKey`, `userPhone`, `phoneDeviceId`, `userPwd`, `userNIName`, `openId`, `accessToken`, `expiredTime`, `userImg`, `bgImg`, `userWxLogin`, `userQqLogin`, `userNum`, `propelling`, `candyNum`, `versionInfoId`, `deleteUser`, `identityId`, `invitationCode`, `firstLogin`, `firstUpdateName`, `dayCandyNum`, `downLoadNumy`, `registerSource`, `registerSystem`, `loginSystem`, `loginTime`, `updateVersion`, `candyFreeze`, `toutiaoCandyDay`, `userType`, `developerStatus`, `userIp`, `phoneMac`, `phoneBrand`, `phoneModel`, `phoneLevel`, `registerChannel`, `btchatStatus`, `loginAddress`, `longitude`, `latitude`, `gender`, `birthday`, `age`, `occupation`, `signature`, `chatNo`, `xingzuo`, `detailsaddr`, `ifvip`, `startvip`, `endvip`, `nearbycount`, `greetuser`, `secret`, `mark`, `userexist`, `city`, `adminid`) VALUES (349231815384367104, '2024-03-26 12:16:19', '2024-03-26 12:16:19', '', '', '88800002', '', '', '毛粤', '', '', '2024-03-26 12:16:19', 'http://files.gamepro.vip/system/headpic/Square/21.png', 'http://files.gamepro.vip/system/bg_1.jpg', '', '', '', 0, 0, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, '2024-03-26 12:16:19', 0, 0, 0, 0, 0, '', '', '', '', '', '', 0, '', 0.00, 0.00, 1, '', 0, '', '', '', '', '', 0, '', '', 0, 0, 0, '', 1, '郑州', NULL);
INSERT INTO `user_entity` (`userId`, `createTime`, `modifyTime`, `userWxLoginKey`, `userQqKey`, `userPhone`, `phoneDeviceId`, `userPwd`, `userNIName`, `openId`, `accessToken`, `expiredTime`, `userImg`, `bgImg`, `userWxLogin`, `userQqLogin`, `userNum`, `propelling`, `candyNum`, `versionInfoId`, `deleteUser`, `identityId`, `invitationCode`, `firstLogin`, `firstUpdateName`, `dayCandyNum`, `downLoadNumy`, `registerSource`, `registerSystem`, `loginSystem`, `loginTime`, `updateVersion`, `candyFreeze`, `toutiaoCandyDay`, `userType`, `developerStatus`, `userIp`, `phoneMac`, `phoneBrand`, `phoneModel`, `phoneLevel`, `registerChannel`, `btchatStatus`, `loginAddress`, `longitude`, `latitude`, `gender`, `birthday`, `age`, `occupation`, `signature`, `chatNo`, `xingzuo`, `detailsaddr`, `ifvip`, `startvip`, `endvip`, `nearbycount`, `greetuser`, `secret`, `mark`, `userexist`, `city`, `adminid`) VALUES (349231815510196224, '2024-03-26 12:16:19', '2024-03-26 12:16:19', '', '', '88800003', '', '', '秦现', '', '', '2024-03-26 12:16:19', 'http://files.gamepro.vip/system/headpic/Square/12.png', 'http://files.gamepro.vip/system/bg_1.jpg', '', '', '', 0, 0, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, '2024-03-26 12:16:19', 0, 0, 0, 0, 0, '', '', '', '', '', '', 0, '', 0.00, 0.00, 1, '', 0, '', '', '', '', '', 0, '', '', 0, 0, 0, '', 1, '郑州', NULL);
INSERT INTO `user_entity` (`userId`, `createTime`, `modifyTime`, `userWxLoginKey`, `userQqKey`, `userPhone`, `phoneDeviceId`, `userPwd`, `userNIName`, `openId`, `accessToken`, `expiredTime`, `userImg`, `bgImg`, `userWxLogin`, `userQqLogin`, `userNum`, `propelling`, `candyNum`, `versionInfoId`, `deleteUser`, `identityId`, `invitationCode`, `firstLogin`, `firstUpdateName`, `dayCandyNum`, `downLoadNumy`, `registerSource`, `registerSystem`, `loginSystem`, `loginTime`, `updateVersion`, `candyFreeze`, `toutiaoCandyDay`, `userType`, `developerStatus`, `userIp`, `phoneMac`, `phoneBrand`, `phoneModel`, `phoneLevel`, `registerChannel`, `btchatStatus`, `loginAddress`, `longitude`, `latitude`, `gender`, `birthday`, `age`, `occupation`, `signature`, `chatNo`, `xingzuo`, `detailsaddr`, `ifvip`, `startvip`, `endvip`, `nearbycount`, `greetuser`, `secret`, `mark`, `userexist`, `city`, `adminid`) VALUES (349231815610859520, '2024-03-26 12:16:19', '2024-03-26 12:16:19', '', '', '88800004', '', '', '苏囚', '', '', '2024-03-26 12:16:19', 'http://files.gamepro.vip/system/headpic/Square/8.png', 'http://files.gamepro.vip/system/bg_1.jpg', '', '', '', 0, 0, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, '2024-03-26 12:16:19', 0, 0, 0, 0, 0, '', '', '', '', '', '', 0, '', 0.00, 0.00, 1, '', 0, '', '', '', '', '', 0, '', '', 0, 0, 0, '', 1, '郑州', NULL);
INSERT INTO `user_entity` (`userId`, `createTime`, `modifyTime`, `userWxLoginKey`, `userQqKey`, `userPhone`, `phoneDeviceId`, `userPwd`, `userNIName`, `openId`, `accessToken`, `expiredTime`, `userImg`, `bgImg`, `userWxLogin`, `userQqLogin`, `userNum`, `propelling`, `candyNum`, `versionInfoId`, `deleteUser`, `identityId`, `invitationCode`, `firstLogin`, `firstUpdateName`, `dayCandyNum`, `downLoadNumy`, `registerSource`, `registerSystem`, `loginSystem`, `loginTime`, `updateVersion`, `candyFreeze`, `toutiaoCandyDay`, `userType`, `developerStatus`, `userIp`, `phoneMac`, `phoneBrand`, `phoneModel`, `phoneLevel`, `registerChannel`, `btchatStatus`, `loginAddress`, `longitude`, `latitude`, `gender`, `birthday`, `age`, `occupation`, `signature`, `chatNo`, `xingzuo`, `detailsaddr`, `ifvip`, `startvip`, `endvip`, `nearbycount`, `greetuser`, `secret`, `mark`, `userexist`, `city`, `adminid`) VALUES (349231815715717120, '2024-03-26 12:16:19', '2024-03-26 12:16:19', '', '', '88800005', '', '', '唐厌', '', '', '2024-03-26 12:16:19', 'http://files.gamepro.vip/system/headpic/Square/25.png', 'http://files.gamepro.vip/system/bg_1.jpg', '', '', '', 0, 0, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, '2024-03-26 12:16:19', 0, 0, 0, 0, 0, '', '', '', '', '', '', 0, '', 0.00, 0.00, 1, '', 0, '', '', '', '', '', 0, '', '', 0, 0, 0, '', 1, '郑州', NULL);
INSERT INTO `user_entity` (`userId`, `createTime`, `modifyTime`, `userWxLoginKey`, `userQqKey`, `userPhone`, `phoneDeviceId`, `userPwd`, `userNIName`, `openId`, `accessToken`, `expiredTime`, `userImg`, `bgImg`, `userWxLogin`, `userQqLogin`, `userNum`, `propelling`, `candyNum`, `versionInfoId`, `deleteUser`, `identityId`, `invitationCode`, `firstLogin`, `firstUpdateName`, `dayCandyNum`, `downLoadNumy`, `registerSource`, `registerSystem`, `loginSystem`, `loginTime`, `updateVersion`, `candyFreeze`, `toutiaoCandyDay`, `userType`, `developerStatus`, `userIp`, `phoneMac`, `phoneBrand`, `phoneModel`, `phoneLevel`, `registerChannel`, `btchatStatus`, `loginAddress`, `longitude`, `latitude`, `gender`, `birthday`, `age`, `occupation`, `signature`, `chatNo`, `xingzuo`, `detailsaddr`, `ifvip`, `startvip`, `endvip`, `nearbycount`, `greetuser`, `secret`, `mark`, `userexist`, `city`, `adminid`) VALUES (349231815807991808, '2024-03-26 12:16:19', '2024-03-26 12:16:19', '', '', '88800006', '', '', '慕容栖', '', '', '2024-03-26 12:16:19', 'http://files.gamepro.vip/system/headpic/Square/17.png', 'http://files.gamepro.vip/system/bg_1.jpg', '', '', '', 0, 0, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, '2024-03-26 12:16:19', 0, 0, 0, 0, 0, '', '', '', '', '', '', 0, '', 0.00, 0.00, 1, '', 0, '', '', '', '', '', 0, '', '', 0, 0, 0, '', 1, '郑州', NULL);
INSERT INTO `user_entity` (`userId`, `createTime`, `modifyTime`, `userWxLoginKey`, `userQqKey`, `userPhone`, `phoneDeviceId`, `userPwd`, `userNIName`, `openId`, `accessToken`, `expiredTime`, `userImg`, `bgImg`, `userWxLogin`, `userQqLogin`, `userNum`, `propelling`, `candyNum`, `versionInfoId`, `deleteUser`, `identityId`, `invitationCode`, `firstLogin`, `firstUpdateName`, `dayCandyNum`, `downLoadNumy`, `registerSource`, `registerSystem`, `loginSystem`, `loginTime`, `updateVersion`, `candyFreeze`, `toutiaoCandyDay`, `userType`, `developerStatus`, `userIp`, `phoneMac`, `phoneBrand`, `phoneModel`, `phoneLevel`, `registerChannel`, `btchatStatus`, `loginAddress`, `longitude`, `latitude`, `gender`, `birthday`, `age`, `occupation`, `signature`, `chatNo`, `xingzuo`, `detailsaddr`, `ifvip`, `startvip`, `endvip`, `nearbycount`, `greetuser`, `secret`, `mark`, `userexist`, `city`, `adminid`) VALUES (349231815929626624, '2024-03-26 12:16:19', '2024-03-26 12:16:19', '', '', '88800007', '', '', '韦炙莽', '', '', '2024-03-26 12:16:19', 'http://files.gamepro.vip/system/headpic/Square/9.png', 'http://files.gamepro.vip/system/bg_1.jpg', '', '', '', 0, 0, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, '2024-03-26 12:16:19', 0, 0, 0, 0, 0, '', '', '', '', '', '', 0, '', 0.00, 0.00, 1, '', 0, '', '', '', '', '', 0, '', '', 0, 0, 0, '', 1, '郑州', NULL);
INSERT INTO `user_entity` (`userId`, `createTime`, `modifyTime`, `userWxLoginKey`, `userQqKey`, `userPhone`, `phoneDeviceId`, `userPwd`, `userNIName`, `openId`, `accessToken`, `expiredTime`, `userImg`, `bgImg`, `userWxLogin`, `userQqLogin`, `userNum`, `propelling`, `candyNum`, `versionInfoId`, `deleteUser`, `identityId`, `invitationCode`, `firstLogin`, `firstUpdateName`, `dayCandyNum`, `downLoadNumy`, `registerSource`, `registerSystem`, `loginSystem`, `loginTime`, `updateVersion`, `candyFreeze`, `toutiaoCandyDay`, `userType`, `developerStatus`, `userIp`, `phoneMac`, `phoneBrand`, `phoneModel`, `phoneLevel`, `registerChannel`, `btchatStatus`, `loginAddress`, `longitude`, `latitude`, `gender`, `birthday`, `age`, `occupation`, `signature`, `chatNo`, `xingzuo`, `detailsaddr`, `ifvip`, `startvip`, `endvip`, `nearbycount`, `greetuser`, `secret`, `mark`, `userexist`, `city`, `adminid`) VALUES (349231816026095616, '2024-03-26 12:16:19', '2024-03-26 12:16:19', '', '', '88800008', '', '', '马瘦泥', '', '', '2024-03-26 12:16:19', 'http://files.gamepro.vip/system/headpic/Square/12.png', 'http://files.gamepro.vip/system/bg_1.jpg', '', '', '', 0, 0, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, '2024-03-26 12:16:19', 0, 0, 0, 0, 0, '', '', '', '', '', '', 0, '', 0.00, 0.00, 1, '', 0, '', '', '', '', '', 0, '', '', 0, 0, 0, '', 1, '郑州', NULL);
INSERT INTO `user_entity` (`userId`, `createTime`, `modifyTime`, `userWxLoginKey`, `userQqKey`, `userPhone`, `phoneDeviceId`, `userPwd`, `userNIName`, `openId`, `accessToken`, `expiredTime`, `userImg`, `bgImg`, `userWxLogin`, `userQqLogin`, `userNum`, `propelling`, `candyNum`, `versionInfoId`, `deleteUser`, `identityId`, `invitationCode`, `firstLogin`, `firstUpdateName`, `dayCandyNum`, `downLoadNumy`, `registerSource`, `registerSystem`, `loginSystem`, `loginTime`, `updateVersion`, `candyFreeze`, `toutiaoCandyDay`, `userType`, `developerStatus`, `userIp`, `phoneMac`, `phoneBrand`, `phoneModel`, `phoneLevel`, `registerChannel`, `btchatStatus`, `loginAddress`, `longitude`, `latitude`, `gender`, `birthday`, `age`, `occupation`, `signature`, `chatNo`, `xingzuo`, `detailsaddr`, `ifvip`, `startvip`, `endvip`, `nearbycount`, `greetuser`, `secret`, `mark`, `userexist`, `city`, `adminid`) VALUES (349231816151924736, '2024-03-26 12:16:19', '2024-03-26 12:16:19', '', '', '88800009', '', '', '常呻', '', '', '2024-03-26 12:16:19', 'http://files.gamepro.vip/system/headpic/Square/15.png', 'http://files.gamepro.vip/system/bg_1.jpg', '', '', '', 0, 0, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, '2024-03-26 12:16:19', 0, 0, 0, 0, 0, '', '', '', '', '', '', 0, '', 0.00, 0.00, 1, '', 0, '', '', '', '', '', 0, '', '', 0, 0, 0, '', 1, '郑州', NULL);
INSERT INTO `user_entity` (`userId`, `createTime`, `modifyTime`, `userWxLoginKey`, `userQqKey`, `userPhone`, `phoneDeviceId`, `userPwd`, `userNIName`, `openId`, `accessToken`, `expiredTime`, `userImg`, `bgImg`, `userWxLogin`, `userQqLogin`, `userNum`, `propelling`, `candyNum`, `versionInfoId`, `deleteUser`, `identityId`, `invitationCode`, `firstLogin`, `firstUpdateName`, `dayCandyNum`, `downLoadNumy`, `registerSource`, `registerSystem`, `loginSystem`, `loginTime`, `updateVersion`, `candyFreeze`, `toutiaoCandyDay`, `userType`, `developerStatus`, `userIp`, `phoneMac`, `phoneBrand`, `phoneModel`, `phoneLevel`, `registerChannel`, `btchatStatus`, `loginAddress`, `longitude`, `latitude`, `gender`, `birthday`, `age`, `occupation`, `signature`, `chatNo`, `xingzuo`, `detailsaddr`, `ifvip`, `startvip`, `endvip`, `nearbycount`, `greetuser`, `secret`, `mark`, `userexist`, `city`, `adminid`) VALUES (349231816244199424, '2024-03-26 12:16:19', '2024-03-26 12:16:19', '', '', '88800010', '', '', '陆价', '', '', '2024-03-26 12:16:19', 'http://files.gamepro.vip/system/headpic/Square/20.png', 'http://files.gamepro.vip/system/bg_1.jpg', '', '', '', 0, 0, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, '2024-03-26 12:16:19', 0, 0, 0, 0, 0, '', '', '', '', '', '', 0, '', 0.00, 0.00, 1, '', 0, '', '', '', '', '', 0, '', '', 0, 0, 0, '', 1, '郑州', NULL);
INSERT INTO `user_entity` (`userId`, `createTime`, `modifyTime`, `userWxLoginKey`, `userQqKey`, `userPhone`, `phoneDeviceId`, `userPwd`, `userNIName`, `openId`, `accessToken`, `expiredTime`, `userImg`, `bgImg`, `userWxLogin`, `userQqLogin`, `userNum`, `propelling`, `candyNum`, `versionInfoId`, `deleteUser`, `identityId`, `invitationCode`, `firstLogin`, `firstUpdateName`, `dayCandyNum`, `downLoadNumy`, `registerSource`, `registerSystem`, `loginSystem`, `loginTime`, `updateVersion`, `candyFreeze`, `toutiaoCandyDay`, `userType`, `developerStatus`, `userIp`, `phoneMac`, `phoneBrand`, `phoneModel`, `phoneLevel`, `registerChannel`, `btchatStatus`, `loginAddress`, `longitude`, `latitude`, `gender`, `birthday`, `age`, `occupation`, `signature`, `chatNo`, `xingzuo`, `detailsaddr`, `ifvip`, `startvip`, `endvip`, `nearbycount`, `greetuser`, `secret`, `mark`, `userexist`, `city`, `adminid`) VALUES (349325819388100608, '2024-03-26 18:29:58', '2024-03-26 18:29:58', '', '', '15888007425', '', '', '皇甫兄', '', '', '2024-03-26 18:29:58', 'https://files.gamepro.vip/system/headpic/Square/40.png', 'https://files.gamepro.vip/system/bg_1.jpg', '', '', '', 0, 0, '', 0, 0, '', 0, 0, 0, 0, 0, 1, 1, '2024-03-26 18:29:58', 0, 0, 0, 0, 0, '', '', '', '', '', '', 0, '', 0.00, 0.00, 1, '', 0, '', '', '', '', '', 0, '', '', 0, 0, 0, 'official', 0, '', NULL);
INSERT INTO `user_entity` (`userId`, `createTime`, `modifyTime`, `userWxLoginKey`, `userQqKey`, `userPhone`, `phoneDeviceId`, `userPwd`, `userNIName`, `openId`, `accessToken`, `expiredTime`, `userImg`, `bgImg`, `userWxLogin`, `userQqLogin`, `userNum`, `propelling`, `candyNum`, `versionInfoId`, `deleteUser`, `identityId`, `invitationCode`, `firstLogin`, `firstUpdateName`, `dayCandyNum`, `downLoadNumy`, `registerSource`, `registerSystem`, `loginSystem`, `loginTime`, `updateVersion`, `candyFreeze`, `toutiaoCandyDay`, `userType`, `developerStatus`, `userIp`, `phoneMac`, `phoneBrand`, `phoneModel`, `phoneLevel`, `registerChannel`, `btchatStatus`, `loginAddress`, `longitude`, `latitude`, `gender`, `birthday`, `age`, `occupation`, `signature`, `chatNo`, `xingzuo`, `detailsaddr`, `ifvip`, `startvip`, `endvip`, `nearbycount`, `greetuser`, `secret`, `mark`, `userexist`, `city`, `adminid`) VALUES (349627612580020224, '2024-03-28 10:52:54', '2024-03-28 10:52:54', '', '', '13523007812', '', '', '田果', '', '', '2024-03-28 10:52:54', 'https://files.gamepro.vip/system/headpic/Square/28.png', 'https://files.gamepro.vip/system/bg_1.jpg', '', '', '', 0, 0, '', 0, 0, '', 0, 0, 0, 0, 0, 1, 1, '2024-03-28 10:52:54', 0, 0, 0, 0, 0, '', '', '', '', '', '', 0, '', 0.00, 0.00, 1, '', 0, '', '', '', '', '', 0, '', '', 0, 0, 0, 'official', 0, '', NULL);
COMMIT;

-- ----------------------------
-- Table structure for user_group
-- ----------------------------
DROP TABLE IF EXISTS `user_group`;
CREATE TABLE `user_group` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `userId` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '群组创建人(user_entity表主键)',
  `userPhone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '群组创建人手机号',
  `groupAddress` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '群组创建位置',
  `longitude` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '群组创建时的经度',
  `latitude` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '群组创建时的纬度',
  `groupId` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '群组在IM服务中的编号',
  `createTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '群组创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT=' <p>';

-- ----------------------------
-- Records of user_group
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
